-- @owner: lihongji
-- @date: 2022/6/17
-- @testpoint: concat_ws拼接函数中character varying类型与其他数据类型拼接
-- @modified by: xiaqi14 2024/12/20 研发代码变更返回精度变化，优化用例


--step1: 建表        expect: 建表成功
drop table if exists t_ustore_concat_ws_0001;
create table t_ustore_concat_ws_0001(
col_1 bigint, col_2 timestamp without time zone, col_3 bool,col_4 decimal,col_5 text ,col_6 smallint ,col_7 char(30),col_8 double precision,col_9 text,col_10 character varying(30),
col_11 bool ,col_12 bytea ,col_13 real ,col_14 numeric ,col_15 blob ,col_16 integer ,col_17 int ,col_18 timestamp with time zone ,col_19 binary_integer ,col_20 interval day to second ,
col_21 boolean, col_22 nchar(30) ,col_23 bigint ,col_24 nchar(100) ,col_25 character(1000) , col_26 text , col_27 float ,col_28 double precision ,col_29 bigint ,col_30  timestamp with time zone ,
col_31 timestamp , col_32 clob ,col_33 interval year to month, col_34 character(30) ,col_35 smallint ,col_36 blob ,col_37 char(300),col_38 float ,col_39 raw(100),col_40 clob ,
col_41 binary_double ,col_42 number(6,2) ,col_43 decimal(6,2) ,col_44 varchar2(50),col_45 varchar(30) ,col_46 nvarchar2(100), col_47 numeric(12,6),col_48 varchar2(50),col_49 date,col_50 clob ,
col_51 integer ,col_52 binary_double ,col_53 decimal(12,6),col_54 raw(8000),col_55 clob ,col_56 varchar2(8000) ,col_57 date ,col_58 number(12,6),col_59 nvarchar2(4000) ,col_60 clob ,
col_61 blob ,col_62 date ,col_63 blob , col_64 varchar(1000),col_65 date
) with (storage_type=ustore);

--step2: 创建序列   expect：创建序列成功
drop sequence if exists s_seq_get_tab_concat_ws;
create sequence s_seq_get_tab_concat_ws increment by 1 start with 100000;

--step3：清空数据    expect：清空数据成功
truncate  table t_ustore_concat_ws_0001;

--step4：数据创造    expect：创造数据成功
begin
 for i in 1..1000 loop
      insert into t_ustore_concat_ws_0001 values(
s_seq_get_tab_concat_ws.nextval,to_timestamp('2019-01-03 14:58:54.000000','YYYY-MM-DD HH24:MI:SS.FFFFFF'),true,3.1415926,lpad('abc','30','a@123&^%djgk'),987,'asjk&%$454',10011.456789445455,lpad('abc','50','a@123&^%djgk'),'字符串',
false,'1001011',315454.1415926,99/4,'101101000111111101010',0,1,to_timestamp('2019-01-04 16:33:47.123456','YYYY-MM-DD HH24:MI:SS.FFFFFF'),'1',(INTERVAL '4 5:12:10.222' DAY TO SECOND(3)),
0,rpad('abc','10','e'),353848,rpad('abc','10','exc'),lpad('abc','30','a@123&^%djgk'),lpad('abc','20','a@123&^%djgk'),9745.548,-99,3141.5,to_timestamp('2019-01-04 16:33:47.123456','YYYY-MM-DD HH24:MI:SS.FFFFFF'),
to_timestamp('2019-01-03 14:58:54.000000','YYYY-MM-DD HH24:MI:SS.FFFFFF'),'a@123&^%djgk',(INTERVAL '12' YEAR),' ','0','101101000111111101010','这是一个字符串',1/2.15,'0FAADB9','a@123&^%djgk',
1.0E+100,3.14,4445.25,rpad('abc','10','&'),lpad('abc','10','&'),'abc&GDsh',125563.141592,rpad('abc','10','e'),'2019-01-03 14:14:12','a@123汉字&^%djgk',
+2,-1.79E+100,98*0.99,'1010101001010','abca@123&^%djgk','abca@123&^%djgk','2019-01-03 14:14:12',25563.1415,'a字符串@123&^%djgk',lpad('10',20,'01010'),
'1001010','2019-01-03 14:14:12','010101111111100000000000000','abc&GDsh','2019-01-03 15:19:00'
);
    end loop;
end;
/

--step5:character varying与其他数据类型拼接       expect:成功
select concat_ws ( col_10 , col_10 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_11 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_12 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_13 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_14 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_15 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_16 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_17 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_18 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_19 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_1 )  from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_20 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_21 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_22 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_23 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_24 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_25 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_26 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_27 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_28 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_29 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_2 )  from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_30 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_31 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_32 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_33 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_34 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_35 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_36 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_37 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_38 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_39 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_3 )  from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_40 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_41 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_42 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_43 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_44 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_45 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_46 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_47 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_48 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_49 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_4 )  from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_50 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_51 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_52 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_53 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_54 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_55 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_56 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_57 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_58 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_59 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_5 )  from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_60 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_61 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_62 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_63 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_64 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_65 ) from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_6 )  from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_7 )  from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_8 )  from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , col_9 )  from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
select concat_ws ( col_10 , '' )     from t_ustore_concat_ws_0001 where col_1<100002 order by 1 for update ;
